package cn.gson.oasys.model.dao.excel;


import cn.gson.oasys.model.entity.excel.Wage;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface WagesDao extends JpaRepository<Wage, Long> {


    @Query("from Wage w where  (w.gh like %?1% or w.xm like %?1% or w.fxny like %?1%)")
    Page<Wage> findAllByName(String k,Pageable pa);

    @Query("from Wage w where  (w.gh like %?1%)")
    Page<Wage> findAllByUserName(String k,Pageable pa);
}
